Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	8390
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	786.7 KiB
Average record size in memory	96.0 B

Variable types

Categorical	1
Numeric	11

Alerts

`Symbol` has a high cardinality: 2295 distinct values	High cardinality
`ESG Score` is highly correlated with `Environmental Pillar Score` and 2 other fields	High correlation
`Environmental Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Social Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Governance Pillar Score` is highly correlated with `ESG Score`	High correlation
`semi-variance (down)` is highly correlated with `VaR (95%)`	High correlation
`VaR (95%)` is highly correlated with `semi-variance (down)`	High correlation
`ESG Score` is highly correlated with `Environmental Pillar Score` and 2 other fields	High correlation
`Environmental Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Social Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Governance Pillar Score` is highly correlated with `ESG Score`	High correlation
`semi-variance (down)` is highly correlated with `VaR (95%)`	High correlation
`VaR (95%)` is highly correlated with `semi-variance (down)`	High correlation
`ESG Score` is highly correlated with `Environmental Pillar Score` and 1 other fields	High correlation
`Environmental Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Social Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`semi-variance (down)` is highly correlated with `VaR (95%)`	High correlation
`VaR (95%)` is highly correlated with `semi-variance (down)`	High correlation
`ESG Score` is highly correlated with `Environmental Pillar Score` and 2 other fields	High correlation
`Environmental Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Social Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Governance Pillar Score` is highly correlated with `ESG Score`	High correlation
`mean-return` is highly correlated with `VaR (95%)`	High correlation
`semi-variance (down)` is highly correlated with `skew` and 1 other fields	High correlation
`kurtosis` is highly correlated with `skew`	High correlation
`skew` is highly correlated with `semi-variance (down)` and 1 other fields	High correlation
`VaR (95%)` is highly correlated with `mean-return` and 1 other fields	High correlation
`ESG Score` has unique values	Unique
`semi-variance (down)` has unique values	Unique
`kurtosis` has unique values	Unique
`skew` has unique values	Unique
`D(ESG, VaR)` has 1658 (19.8%) zeros	Zeros

Reproduction

Analysis started	2022-09-27 07:55:23.971507
Analysis finished	2022-09-27 07:55:36.822720
Duration	12.85 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Symbol
Categorical

HIGH CARDINALITY

Distinct	2295
Distinct (%)	27.4%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

GIII.OQ	7
BBY.N	7
AEO.N	7
HIBB.OQ	7
VSTO.N	7
Other values (2290)	8355

Length

Max length	8
Median length	7
Mean length	5.828843862
Min length	3

Characters and Unicode

Total characters	48904
Distinct characters	35
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	403 ?
Unique (%)	4.8%

Sample

1st row	360.AX
2nd row	360.AX
3rd row	A.N
4th row	A.N
5th row	A.N

Common Values

Value	Count	Frequency (%)
GIII.OQ	7	0.1%
BBY.N	7	0.1%
AEO.N	7	0.1%
HIBB.OQ	7	0.1%
VSTO.N	7	0.1%
KMX.N	7	0.1%
WSM.N	7	0.1%
EXPR.N	7	0.1%
ENS.N	7	0.1%
LOW.N	7	0.1%
Other values (2285)	8320	99.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
giii.oq	7	0.1%
avav.oq	7	0.1%
bby.n	7	0.1%
mod.n	7	0.1%
dds.n	7	0.1%
dg.n	7	0.1%
gme.n	7	0.1%
dbi.n	7	0.1%
casy.oq	7	0.1%
schl.oq	7	0.1%
Other values (2285)	8320	99.2%

Most occurring characters

Value	Count	Frequency (%)
.	8390	17.2%
N	6321	12.9%
O	4575	9.4%
Q	3554	7.3%
C	2208	4.5%
A	2080	4.3%
S	1906	3.9%
T	1817	3.7%
R	1760	3.6%
M	1456	3.0%
Other values (25)	14837	30.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	40466	82.7%
Other Punctuation	8390	17.2%
Lowercase Letter	38	0.1%
Decimal Number	6	< 0.1%
Connector Punctuation	4	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	6321	15.6%
O	4575	11.3%
Q	3554	8.8%
C	2208	5.5%
A	2080	5.1%
S	1906	4.7%
T	1817	4.5%
R	1760	4.3%
M	1456	3.6%
I	1445	3.6%
Other values (16)	13344	33.0%

Lowercase Letter

Value	Count	Frequency (%)
a	23	60.5%
b	10	26.3%
p	4	10.5%
q	1	2.6%

Decimal Number

Value	Count	Frequency (%)
3	2	33.3%
6	2	33.3%
0	2	33.3%

Other Punctuation

Value	Count	Frequency (%)
.	8390	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	40504	82.8%
Common	8400	17.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	6321	15.6%
O	4575	11.3%
Q	3554	8.8%
C	2208	5.5%
A	2080	5.1%
S	1906	4.7%
T	1817	4.5%
R	1760	4.3%
M	1456	3.6%
I	1445	3.6%
Other values (20)	13382	33.0%

Common

Value	Count	Frequency (%)
.	8390	99.9%
_	4	< 0.1%
3	2	< 0.1%
6	2	< 0.1%
0	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48904	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	8390	17.2%
N	6321	12.9%
O	4575	9.4%
Q	3554	7.3%
C	2208	4.5%
A	2080	4.3%
S	1906	3.9%
T	1817	3.7%
R	1760	3.6%
M	1456	3.0%
Other values (25)	14837	30.3%

Year
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2018.890942

Minimum	2016
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	2016
5-th percentile	2016
Q1	2018
median	2019
Q3	2020
95-th percentile	2021
Maximum	2022
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.672251556
Coefficient of variation (CV)	0.0008283020749
Kurtosis	-1.034924958
Mean	2018.890942
Median Absolute Deviation (MAD)	1
Skewness	-0.2705443575
Sum	16938495
Variance	2.796425267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2020	1858	22.1%
2019	1570	18.7%
2021	1558	18.6%
2018	1244	14.8%
2017	1043	12.4%
2016	985	11.7%
2022	132	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2016	985	11.7%
2017	1043	12.4%
2018	1244	14.8%
2019	1570	18.7%
2020	1858	22.1%
2021	1558	18.6%
2022	132	1.6%

Value	Count	Frequency (%)
2022	132	1.6%
2021	1558	18.6%
2020	1858	22.1%
2019	1570	18.7%
2018	1244	14.8%
2017	1043	12.4%
2016	985	11.7%

ESG Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	8390
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.1775578

Minimum	3.806763196
Maximum	94.44445553
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	3.806763196
5-th percentile	17.02965548
Q1	30.5849707
median	43.18626799
Q3	59.03944378
95-th percentile	78.481338
Maximum	94.44445553
Range	90.63769233
Interquartile range (IQR)	28.45447307

Descriptive statistics

Standard deviation	18.82265547
Coefficient of variation (CV)	0.4166372947
Kurtosis	-0.7115598409
Mean	45.1775578
Median Absolute Deviation (MAD)	14.05672394
Skewness	0.2793725942
Sum	379039.71
Variance	354.2923588
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27.08101803	1	< 0.1%
26.87866445	1	< 0.1%
15.58532593	1	< 0.1%
17.0528031	1	< 0.1%
43.18368707	1	< 0.1%
27.40319628	1	< 0.1%
28.90781027	1	< 0.1%
27.52122772	1	< 0.1%
28.88156102	1	< 0.1%
67.4537551	1	< 0.1%
Other values (8380)	8380	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.806763196	1	< 0.1%
5.114833664	1	< 0.1%
5.776484991	1	< 0.1%
5.794444127	1	< 0.1%
5.974997495	1	< 0.1%
6.152221193	1	< 0.1%
6.221658567	1	< 0.1%
6.686398355	1	< 0.1%
6.81418215	1	< 0.1%
6.868101403	1	< 0.1%

Value	Count	Frequency (%)
94.44445553	1	< 0.1%
93.53912565	1	< 0.1%
93.32784124	1	< 0.1%
92.80650836	1	< 0.1%
92.61992314	1	< 0.1%
92.31516263	1	< 0.1%
92.1429952	1	< 0.1%
91.90508406	1	< 0.1%
91.85503349	1	< 0.1%
91.47686123	1	< 0.1%

Environmental Pillar Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7249
Distinct (%)	86.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.66414699

Minimum	0.027777778
Maximum	97.98022505
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	0.027777778
5-th percentile	1.830951138
Q1	9.301939765
median	25.35933463
Q3	52.52109455
95-th percentile	81.62031074
Maximum	97.98022505
Range	97.95244727
Interquartile range (IQR)	43.21915478

Descriptive statistics

Standard deviation	26.09604144
Coefficient of variation (CV)	0.7989200347
Kurtosis	-0.8080771856
Mean	32.66414699
Median Absolute Deviation (MAD)	18.97278
Skewness	0.6148309379
Sum	274052.1932
Variance	681.003379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21.15270351	121	1.4%
1.740581784	52	0.6%
1.771771772	39	0.5%
1.608821403	33	0.4%
17.53569212	20	0.2%
20.39408867	20	0.2%
37.31707317	18	0.2%
4.945054945	18	0.2%
1.924818841	16	0.2%
6.302521008	16	0.2%
Other values (7239)	8037	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.027777778	1	< 0.1%
0.086956522	1	< 0.1%
0.088593577	1	< 0.1%
0.091672296	1	< 0.1%
0.142146411	1	< 0.1%
0.142450142	1	< 0.1%
0.146297126	1	< 0.1%
0.194444444	1	< 0.1%
0.217013889	1	< 0.1%
0.255558395	1	< 0.1%

Value	Count	Frequency (%)
97.98022505	1	< 0.1%
97.69705095	1	< 0.1%
97.25520303	1	< 0.1%
97.16815059	1	< 0.1%
97.16090883	1	< 0.1%
97.02299593	1	< 0.1%
96.82619138	1	< 0.1%
96.67922137	1	< 0.1%
96.62206002	1	< 0.1%
96.54273654	1	< 0.1%

Social Pillar Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8352
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.89734695

Minimum	0.453490413
Maximum	97.83313378
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	0.453490413
5-th percentile	15.27588208
Q1	30.20751794
median	45.20856376
Q3	62.31384454
95-th percentile	84.58797876
Maximum	97.83313378
Range	97.37964337
Interquartile range (IQR)	32.1063266

Descriptive statistics

Standard deviation	21.13387719
Coefficient of variation (CV)	0.4506412104
Kurtosis	-0.7259666039
Mean	46.89734695
Median Absolute Deviation (MAD)	15.90164398
Skewness	0.2685154
Sum	393468.7409
Variance	446.6407652
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28.95333105	4	< 0.1%
25.1054216	3	< 0.1%
50	3	< 0.1%
25.91686339	3	< 0.1%
28.96555825	3	< 0.1%
22.47251138	3	< 0.1%
31.06869795	3	< 0.1%
23.84305671	3	< 0.1%
35.39530578	2	< 0.1%
10.9375	2	< 0.1%
Other values (8342)	8361	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.453490413	1	< 0.1%
1.250985028	1	< 0.1%
1.374185668	1	< 0.1%
2.058498218	1	< 0.1%
2.260348584	1	< 0.1%
2.440956221	1	< 0.1%
2.704071629	1	< 0.1%
2.708743072	1	< 0.1%
2.862323994	1	< 0.1%
2.868357488	1	< 0.1%

Value	Count	Frequency (%)
97.83313378	1	< 0.1%
97.69370496	1	< 0.1%
97.66874295	1	< 0.1%
97.65506268	1	< 0.1%
97.57901244	1	< 0.1%
97.39413182	1	< 0.1%
97.39293525	1	< 0.1%
97.34833138	1	< 0.1%
97.25672305	1	< 0.1%
97.23474375	1	< 0.1%

Governance Pillar Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8359
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53.00145002

Minimum	0.713528414
Maximum	99.49668624
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	0.713528414
5-th percentile	16.13415441
Q1	36.54946887
median	54.65678837
Q3	70.23126631
95-th percentile	85.36482267
Maximum	99.49668624
Range	98.78315783
Interquartile range (IQR)	33.68179744

Descriptive statistics

Standard deviation	21.54495779
Coefficient of variation (CV)	0.4064975162
Kurtosis	-0.8158104855
Mean	53.00145002
Median Absolute Deviation (MAD)	16.75195087
Skewness	-0.2135485784
Sum	444682.1657
Variance	464.1852061
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
58.43062853	2	< 0.1%
73.41723549	2	< 0.1%
25.72314815	2	< 0.1%
62.46257571	2	< 0.1%
35.74819745	2	< 0.1%
60.88635921	2	< 0.1%
70.70108077	2	< 0.1%
18.78816794	2	< 0.1%
51.31558514	2	< 0.1%
29.01081425	2	< 0.1%
Other values (8349)	8370	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.713528414	1	< 0.1%
1.21894023	1	< 0.1%
1.449805879	1	< 0.1%
1.621528968	1	< 0.1%
1.670932878	1	< 0.1%
1.693686007	1	< 0.1%
1.741942324	1	< 0.1%
1.77374894	1	< 0.1%
1.958191126	1	< 0.1%
2.006541524	1	< 0.1%

Value	Count	Frequency (%)
99.49668624	1	< 0.1%
98.61065544	1	< 0.1%
98.29931336	1	< 0.1%
98.1416741	1	< 0.1%
97.5232521	1	< 0.1%
97.49964879	1	< 0.1%
97.30143852	1	< 0.1%
97.02811555	1	< 0.1%
96.77316411	1	< 0.1%
96.67393058	1	< 0.1%

mean-return
Real number (ℝ)

HIGH CORRELATION

Distinct	8385
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.002510868964

Minimum	-0.552090105
Maximum	0.5359062215
Zeros	0
Zeros (%)	0.0%
Negative	3485
Negative (%)	41.5%
Memory size	65.7 KiB

Quantile statistics

Minimum	-0.552090105
5-th percentile	-0.07413523606
Q1	-0.01588608457
median	0.00623143584
Q3	0.02532615983
95-th percentile	0.06483100316
Maximum	0.5359062215
Range	1.087996327
Interquartile range (IQR)	0.0412122444

Descriptive statistics

Standard deviation	0.04782904166
Coefficient of variation (CV)	19.04880038
Kurtosis	13.67467632
Mean	0.002510868964
Median Absolute Deviation (MAD)	0.02046234336
Skewness	-1.195183679
Sum	21.0661906
Variance	0.002287617226
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.039470474	2	< 0.1%
0.06301338005	2	< 0.1%
0.03146094461	2	< 0.1%
0.01152288233	2	< 0.1%
1.513940488 × 10^-17	2	< 0.1%
-0.03398650302	1	< 0.1%
0.06324762159	1	< 0.1%
-0.007642441634	1	< 0.1%
0.03543258288	1	< 0.1%
0.0175059022	1	< 0.1%
Other values (8375)	8375	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.552090105	1	< 0.1%
-0.5304138823	1	< 0.1%
-0.4925745599	1	< 0.1%
-0.4094096847	1	< 0.1%
-0.4019158167	1	< 0.1%
-0.3896555938	1	< 0.1%
-0.3483979822	1	< 0.1%
-0.3346418915	1	< 0.1%
-0.3307936064	1	< 0.1%
-0.31315733	1	< 0.1%

Value	Count	Frequency (%)
0.5359062215	1	< 0.1%
0.2835265788	1	< 0.1%
0.2558097662	1	< 0.1%
0.2551809226	1	< 0.1%
0.2494473479	1	< 0.1%
0.2376677679	1	< 0.1%
0.2321204633	1	< 0.1%
0.2282888654	1	< 0.1%
0.2206205853	1	< 0.1%
0.2199829472	1	< 0.1%

semi-variance (down)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	8390
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-4.592106598

Minimum	-13.09781826
Maximum	2.361212071
Zeros	0
Zeros (%)	0.0%
Negative	8375
Negative (%)	99.8%
Memory size	65.7 KiB

Quantile statistics

Minimum	-13.09781826
5-th percentile	-6.698866661
Q1	-5.518276647
median	-4.669203134
Q3	-3.694230073
95-th percentile	-2.215815379
Maximum	2.361212071
Range	15.45903034
Interquartile range (IQR)	1.824046574

Descriptive statistics

Standard deviation	1.424582521
Coefficient of variation (CV)	-0.3102241837
Kurtosis	1.579000354
Mean	-4.592106598
Median Absolute Deviation (MAD)	0.9067105853
Skewness	-0.07244649727
Sum	-38527.77436
Variance	2.029435358
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5.516181695	1	< 0.1%
-3.545042065	1	< 0.1%
-1.964712632	1	< 0.1%
-5.295323199	1	< 0.1%
-4.453520159	1	< 0.1%
-5.039787236	1	< 0.1%
-2.639390986	1	< 0.1%
-3.463008213	1	< 0.1%
-3.630449637	1	< 0.1%
-4.030093094	1	< 0.1%
Other values (8380)	8380	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13.09781826	1	< 0.1%
-12.19511323	1	< 0.1%
-12.18932274	1	< 0.1%
-12.15266021	1	< 0.1%
-12.00213547	1	< 0.1%
-11.72729931	1	< 0.1%
-11.38823018	1	< 0.1%
-11.35932499	1	< 0.1%
-11.2999589	1	< 0.1%
-11.23595931	1	< 0.1%

Value	Count	Frequency (%)
2.361212071	1	< 0.1%
1.481894065	1	< 0.1%
1.034879097	1	< 0.1%
0.9784689192	1	< 0.1%
0.9275232992	1	< 0.1%
0.8172531651	1	< 0.1%
0.5311511835	1	< 0.1%
0.5211315162	1	< 0.1%
0.2427456491	1	< 0.1%
0.2421131788	1	< 0.1%

kurtosis
Real number (ℝ)

HIGH CORRELATION
UNIQUE

Distinct	8390
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.676361517

Minimum	-4.771690305
Maximum	10.66785002
Zeros	0
Zeros (%)	0.0%
Negative	3710
Negative (%)	44.2%
Memory size	65.7 KiB

Quantile statistics

Minimum	-4.771690305
5-th percentile	-1.397095342
Q1	-0.6374184458
median	0.2110665923
Q3	1.478189565
95-th percentile	4.462382098
Maximum	10.66785002
Range	15.43954032
Interquartile range (IQR)	2.115608011

Descriptive statistics

Standard deviation	1.848141859
Coefficient of variation (CV)	2.732476364
Kurtosis	2.280649397
Mean	0.676361517
Median Absolute Deviation (MAD)	0.9766243352
Skewness	1.393491393
Sum	5674.673128
Variance	3.41562833
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.6328257409	1	< 0.1%
2.094013783	1	< 0.1%
5.791509142	1	< 0.1%
0.5811194514	1	< 0.1%
-1.361904149	1	< 0.1%
-0.668974197	1	< 0.1%
-0.8217128779	1	< 0.1%
0.3717529472	1	< 0.1%
0.1667980481	1	< 0.1%
0.2797491525	1	< 0.1%
Other values (8380)	8380	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4.771690305	1	< 0.1%
-3.303480138	1	< 0.1%
-3.283662493	1	< 0.1%
-3.010231764	1	< 0.1%
-2.775623454	1	< 0.1%
-2.772284067	1	< 0.1%
-2.768118263	1	< 0.1%
-2.753330548	1	< 0.1%
-2.719587297	1	< 0.1%
-2.712449621	1	< 0.1%

Value	Count	Frequency (%)
10.66785002	1	< 0.1%
10.39619826	1	< 0.1%
10.39230482	1	< 0.1%
9.991123526	1	< 0.1%
9.330673785	1	< 0.1%
9.272796292	1	< 0.1%
9.136219555	1	< 0.1%
8.969254615	1	< 0.1%
8.909863957	1	< 0.1%
8.867227454	1	< 0.1%

skew
Real number (ℝ)

HIGH CORRELATION
UNIQUE

Distinct	8390
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.1355040776

Minimum	-3.243905543
Maximum	3.118139779
Zeros	1
Zeros (%)	< 0.1%
Negative	4739
Negative (%)	56.5%
Memory size	65.7 KiB

Quantile statistics

Minimum	-3.243905543
5-th percentile	-1.63404865
Q1	-0.7022596437
median	-0.1395536166
Q3	0.4448158851
95-th percentile	1.326255899
Maximum	3.118139779
Range	6.362045322
Interquartile range (IQR)	1.147075529

Descriptive statistics

Standard deviation	0.8902627537
Coefficient of variation (CV)	-6.570007115
Kurtosis	0.2027304549
Mean	-0.1355040776
Median Absolute Deviation (MAD)	0.5739383982
Skewness	0.007182582218
Sum	-1136.879211
Variance	0.7925677707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.06114140649	1	< 0.1%
1.208238014	1	< 0.1%
-2.22482193	1	< 0.1%
0.2302402114	1	< 0.1%
0.3795195494	1	< 0.1%
0.671885387	1	< 0.1%
-0.4062157682	1	< 0.1%
-0.6759351596	1	< 0.1%
0.9950146676	1	< 0.1%
-0.7931006897	1	< 0.1%
Other values (8380)	8380	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3.243905543	1	< 0.1%
-3.192624611	1	< 0.1%
-3.192145101	1	< 0.1%
-2.95715309	1	< 0.1%
-2.91591035	1	< 0.1%
-2.8410198	1	< 0.1%
-2.839157001	1	< 0.1%
-2.816467798	1	< 0.1%
-2.803226022	1	< 0.1%
-2.794186419	1	< 0.1%

Value	Count	Frequency (%)
3.118139779	1	< 0.1%
2.939550184	1	< 0.1%
2.900624226	1	< 0.1%
2.846950478	1	< 0.1%
2.815081958	1	< 0.1%
2.781616199	1	< 0.1%
2.727624363	1	< 0.1%
2.692684592	1	< 0.1%
2.674059504	1	< 0.1%
2.579003458	1	< 0.1%

VaR (95%)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8383
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.5189475658

Minimum	-1.792194881
Maximum	0.3791338345
Zeros	1
Zeros (%)	< 0.1%
Negative	8369
Negative (%)	99.7%
Memory size	65.7 KiB

Quantile statistics

Minimum	-1.792194881
5-th percentile	-0.7739480376
Q1	-0.6047985464
median	-0.5075446769
Q3	-0.4212457737
95-th percentile	-0.3104999932
Maximum	0.3791338345
Range	2.171328715
Interquartile range (IQR)	0.1835527727

Descriptive statistics

Standard deviation	0.1481418308
Coefficient of variation (CV)	-0.285465894
Kurtosis	2.766912075
Mean	-0.5189475658
Median Absolute Deviation (MAD)	0.09145573009
Skewness	-0.3641674853
Sum	-4353.970077
Variance	0.02194600203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.7024226197	3	< 0.1%
-0.4870364059	2	< 0.1%
-0.5994360052	2	< 0.1%
-0.6540636108	2	< 0.1%
-0.5628779058	2	< 0.1%
-0.6425695246	2	< 0.1%
-0.755404264	1	< 0.1%
-0.4077321911	1	< 0.1%
-0.4995174022	1	< 0.1%
-0.7777629054	1	< 0.1%
Other values (8373)	8373	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1.792194881	1	< 0.1%
-1.511595705	1	< 0.1%
-1.258391589	1	< 0.1%
-1.213207145	1	< 0.1%
-1.186420538	1	< 0.1%
-1.180367491	1	< 0.1%
-1.176366821	1	< 0.1%
-1.171902307	1	< 0.1%
-1.161085839	1	< 0.1%
-1.152457491	1	< 0.1%

Value	Count	Frequency (%)
0.3791338345	1	< 0.1%
0.3712222028	1	< 0.1%
0.3203540011	1	< 0.1%
0.3119561264	1	< 0.1%
0.3001288553	1	< 0.1%
0.2382145578	1	< 0.1%
0.2159018615	1	< 0.1%
0.2101796825	1	< 0.1%
0.1795995019	1	< 0.1%
0.1708923868	1	< 0.1%

D(ESG, VaR)
Real number (ℝ_≥0)

ZEROS

Distinct	6733
Distinct (%)	80.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6199610107

Minimum	0
Maximum	3.615984026
Zeros	1658
Zeros (%)	19.8%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.1832210288
median	0.5860961193
Q3	0.9455968523
95-th percentile	1.503668201
Maximum	3.615984026
Range	3.615984026
Interquartile range (IQR)	0.7623758235

Descriptive statistics

Standard deviation	0.5041363533
Coefficient of variation (CV)	0.8131742878
Kurtosis	0.5868149427
Mean	0.6199610107
Median Absolute Deviation (MAD)	0.3791559878
Skewness	0.7070442648
Sum	5201.47288
Variance	0.2541534627
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1658	19.8%
0.266705122	1	< 0.1%
1.452176266	1	< 0.1%
0.4700978713	1	< 0.1%
0.3561257261	1	< 0.1%
1.811131678	1	< 0.1%
1.658559512	1	< 0.1%
0.8978131146	1	< 0.1%
0.8583689469	1	< 0.1%
1.21919933	1	< 0.1%
Other values (6723)	6723	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1658	19.8%
0.004160431578	1	< 0.1%
0.005446679126	1	< 0.1%
0.007108419727	1	< 0.1%
0.008240727628	1	< 0.1%
0.009104822992	1	< 0.1%
0.009721754667	1	< 0.1%
0.01017536824	1	< 0.1%
0.01064876301	1	< 0.1%
0.01343308698	1	< 0.1%

Value	Count	Frequency (%)
3.615984026	1	< 0.1%
3.609108634	1	< 0.1%
3.337443128	1	< 0.1%
3.272466785	1	< 0.1%
3.041692242	1	< 0.1%
2.956914105	1	< 0.1%
2.83997234	1	< 0.1%
2.820178117	1	< 0.1%
2.725182555	1	< 0.1%
2.705378608	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Symbol	Year	ESG Score	Environmental Pillar Score	Social Pillar Score	Governance Pillar Score	mean-return	semi-variance (down)	kurtosis	skew	VaR (95%)	D(ESG, VaR)
0	360.AX	2020.0	27.081018	8.916667	43.015144	18.809271	0.032846	-5.516182	-0.632826	0.061141	-0.414228	0.000000
1	360.AX	2021.0	31.410958	8.453608	45.972210	25.759307	0.025825	-5.143267	1.742724	-0.646043	-0.422275	0.201732
2	A.N	2017.0	87.595065	77.060658	92.792375	85.667996	0.035512	-4.960090	0.455790	0.720648	-0.458719	0.000000
3	A.N	2018.0	89.489253	78.045737	94.201817	88.624684	-0.061043	-5.414678	0.610308	0.850044	-0.545839	0.630184
4	A.N	2019.0	88.330855	79.335997	94.505273	84.398806	-0.029269	-4.130051	0.126243	-0.828252	-0.611349	0.499537
5	A.N	2020.0	87.577489	79.958977	93.599370	83.203984	0.045653	-1.305710	4.900414	-1.988309	-0.804262	0.884134
6	AA.N	2016.0	87.186605	85.832330	81.590386	98.299313	0.026276	-5.248673	0.036191	-0.293729	-0.398527	0.000000
7	AA.N	2017.0	87.273109	90.333748	79.472149	95.671099	-0.021786	-6.066246	0.566293	-0.682118	-0.432855	0.393557
8	AA.N	2018.0	86.619978	88.383537	79.128995	96.369097	-0.033796	-5.069203	-0.703649	-0.791101	-0.516679	0.661951
9	AA.N	2019.0	88.078825	87.347163	83.474247	96.673931	-0.039699	-4.192338	2.266191	-1.274915	-0.606671	0.600200

Last rows

	Symbol	Year	ESG Score	Environmental Pillar Score	Social Pillar Score	Governance Pillar Score	mean-return	semi-variance (down)	kurtosis	skew	VaR (95%)	D(ESG, VaR)
8380	ZUMZ.OQ	2022.0	23.972230	4.646465	28.382288	28.735048	-0.110370	-5.305590	-0.820491	-0.116846	-0.584965	0.964042
8381	ZUO.N	2020.0	36.287529	3.083333	54.970658	30.160537	0.017291	-3.988113	1.256732	-0.901465	-0.567121	0.000000
8382	ZUO.N	2021.0	53.918785	27.848701	66.407377	50.985744	0.062855	-5.960060	-0.551396	0.410789	-0.256345	1.976230
8383	ZUO.N	2022.0	49.730061	27.336439	60.100005	47.518473	-0.014564	-5.322589	-2.006538	0.046289	-0.481962	1.574090
8384	ZWS.N	2016.0	22.323763	3.080808	31.548591	33.320535	0.077867	-3.215518	-1.032795	0.420287	-0.580710	0.000000
8385	ZWS.N	2017.0	21.756603	4.250060	27.085541	35.777625	-0.029082	-2.234910	2.814027	-1.311767	-0.789175	0.963631
8386	ZWS.N	2018.0	22.966453	4.193398	24.531598	43.442041	-0.127620	-2.601868	-1.053860	-0.274952	-0.772873	0.238858
8387	ZWS.N	2019.0	42.385059	47.923594	36.354082	43.646098	0.012917	-3.339850	6.009275	2.079474	-0.666787	1.036793
8388	ZWS.N	2020.0	59.566298	53.797153	76.736643	43.977042	-0.038499	-2.857335	-0.321493	-0.129591	-0.732486	0.150479
8389	ZWS.N	2021.0	59.809391	70.174636	76.569419	25.396839	-0.017465	-4.554677	0.371196	1.074856	-0.567442	0.840085

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows